Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_OLAP2_AW_CUBE_MEASURES

`ALL_OLAP2_AW_CUBE_MEASURES` lists the measures of cubes in standard form analytic workspaces.

The `ALL_OLAP2_AW_CUBE_MEASURES` view uses the direct analytic workspace metadata access process to rapidly return information about standard form metadata. It does not use a caching mechanism and is unaffected by `CWM2_OLAP_METADATA_REFRESH`. See Chapter 19 for more information.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`AW_OWNER` | `VARCHAR2(30)` |  | Owner of the analytic workspace.
`AW_NAME` | `VARCHAR2(30)` |  | Name of the analytic workspace.
`AW_CUBE_NAME` | `VARCHAR2(90)` |  | Name of a cube in the analytic workspace.
`AW_MEASURE_NAME` | `VARCHAR2(1000)` |  | Logical name of a measure of the cube.
`AW_PHYSICAL_OBJECT` | `VARCHAR2(4000)` |  | Standard form name of the measure.
`MEASURE_SOURCE_NAME` | `VARCHAR2(1000)` |  | Name of the source measure in the OLAP Catalog.
`DISPLAY_NAME` | `VARCHAR2(1000)` |  | Display name for the measure in the analytic workspace.
`DESCRIPTION` | `VARCHAR2(1000)` |  | Description of the measure in the analytic workspace.
`IS_AGGREGATEABLE` | `VARCHAR2(1000)` |  | Whether or not this measure can be aggregated with the OLAP DML `AGGREGATE` command. The value is `YES` if the measure is implemented as an OLAP variable or if its underlying storage is a variable. For example, the measure could be implemented as a formula whose value is stored in a variable.